Dataset statistics
| Number of variables | 38 |
|---|---|
| Number of observations | 180508 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 271.2 MiB |
| Average record size in memory | 1.5 KiB |
Variable types
| CAT | 20 |
|---|---|
| NUM | 13 |
| BOOL | 2 |
| DATE | 2 |
| URL | 1 |
Reproduction
| Analysis started | 2020-04-09 10:12:19.797816 |
|---|---|
| Analysis finished | 2020-04-09 10:29:52.423695 |
| Version | pandas-profiling v2.5.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Customer City has a high cardinality: 562 distinct values | High cardinality |
Customer Fname has a high cardinality: 775 distinct values | High cardinality |
Customer Lname has a high cardinality: 1109 distinct values | High cardinality |
Customer Street has a high cardinality: 7456 distinct values | High cardinality |
Order City has a high cardinality: 3597 distinct values | High cardinality |
Order Country has a high cardinality: 164 distinct values | High cardinality |
Order State has a high cardinality: 1089 distinct values | High cardinality |
Product Name has a high cardinality: 118 distinct values | High cardinality |
Longitude is highly correlated with Customer Zipcode | High Correlation |
Customer Zipcode is highly correlated with Longitude | High Correlation |
Sales is highly correlated with Sales per customer | High Correlation |
Sales per customer is highly correlated with Sales | High Correlation |
Customer State is highly correlated with Customer Country | High Correlation |
Customer Country is highly correlated with Customer State | High Correlation |
Department Name is highly correlated with Category Name | High Correlation |
Category Name is highly correlated with Department Name | High Correlation |
Order Region is highly correlated with Market | High Correlation |
Market is highly correlated with Order Region | High Correlation |
Order Status is highly correlated with Type | High Correlation |
Type is highly correlated with Order Status | High Correlation |
Shipping Mode is highly correlated with Days for shipment (scheduled) | High Correlation |
Days for shipment (scheduled) is highly correlated with Shipping Mode | High Correlation |
Days for shipping (real) has 5080 (2.8%) zeros | Zeros |
Order Item Discount has 10028 (5.6%) zeros | Zeros |
Order Item Discount Rate has 10028 (5.6%) zeros | Zeros |
| Distinct count | 180508 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 90259.03469 |
|---|---|
| Minimum | 0 |
| Maximum | 180518 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 9025.35 |
| Q1 | 45128.75 |
| median | 90259.5 |
| Q3 | 135389.25 |
| 95-th percentile | 171492.65 |
| Maximum | 180518 |
| Range | 180518 |
| Interquartile range (IQR) | 90260.5 |
Descriptive statistics
| Standard deviation | 52111.93206 |
|---|---|
| Coefficient of variation (CV) | 0.5773597317 |
| Kurtosis | -1.200018572 |
| Mean | 90259.03469 |
| Median Absolute Deviation (MAD) | 45130.33252 |
| Skewness | -2.125550754e-05 |
| Sum | 1.629247783e+10 |
| Variance | 2715653463 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 0. 180518.], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 67082 | 1 | < 0.1% | |
| 132458 | 1 | < 0.1% | |
| 138601 | 1 | < 0.1% | |
| 136552 | 1 | < 0.1% | |
| 159079 | 1 | < 0.1% | |
| 157030 | 1 | < 0.1% | |
| 163173 | 1 | < 0.1% | |
| 161124 | 1 | < 0.1% | |
| 150883 | 1 | < 0.1% | |
| Other values (180498) | 180498 | > 99.9% |
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 180518 | 1 | < 0.1% | |
| 180517 | 1 | < 0.1% | |
| 180516 | 1 | < 0.1% | |
| 180515 | 1 | < 0.1% | |
| 180514 | 1 | < 0.1% |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| DEBIT | |
|---|---|
| TRANSFER | |
| PAYMENT | |
| CASH |
| Value | Count | Frequency (%) | |
| DEBIT | 69290 | 38.4% | |
| TRANSFER | 49880 | 27.6% | |
| PAYMENT | 41722 | 23.1% | |
| CASH | 19616 | 10.9% |
Length
| Max length | 8 |
|---|---|
| Mean length | 6.182595785 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 15 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 15 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 15 | 100.0% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.497673233 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 5080 |
| Zeros (%) | 2.8% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.623742756 |
|---|---|
| Coefficient of variation (CV) | 0.4642351208 |
| Kurtosis | -1.007927277 |
| Mean | 3.497673233 |
| Median Absolute Deviation (MAD) | 1.423789438 |
| Skewness | 0.08475022722 |
| Sum | 631358 |
| Variance | 2.636540537 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.5 1.5 2.5 5.5 6. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 2 | 56613 | 31.4% | |
| 3 | 28764 | 15.9% | |
| 6 | 28723 | 15.9% | |
| 4 | 28510 | 15.8% | |
| 5 | 28161 | 15.6% | |
| 0 | 5080 | 2.8% | |
| 1 | 4657 | 2.6% |
| Value | Count | Frequency (%) | |
| 0 | 5080 | 2.8% | |
| 1 | 4657 | 2.6% | |
| 2 | 56613 | 31.4% | |
| 3 | 28764 | 15.9% | |
| 4 | 28510 | 15.8% |
| Value | Count | Frequency (%) | |
| 6 | 28723 | 15.9% | |
| 5 | 28161 | 15.6% | |
| 4 | 28510 | 15.8% | |
| 3 | 28764 | 15.9% | |
| 2 | 56613 | 31.4% |
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 4 | |
|---|---|
| 2 | |
| 1 | |
| 0 | 9737 |
| Value | Count | Frequency (%) | |
| 4 | 107745 | 59.7% | |
| 2 | 35214 | 19.5% | |
| 1 | 27812 | 15.4% | |
| 0 | 9737 | 5.4% |
Length
| Max length | 1 |
|---|---|
| Mean length | 1 |
| Min length | 1 |
| Value | Count | Frequency (%) | |
| Decimal_Number | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| Common | 4 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 4 | 100.0% |
Benefit per order
Real number (ℝ)
| Distinct count | 21996 |
|---|---|
| Unique (%) | 12.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.97156317 |
|---|---|
| Minimum | -4274.97998 |
| Maximum | 911.7999878 |
| Zeros | 1177 |
| Zeros (%) | 0.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -4274.97998 |
|---|---|
| 5-th percentile | -139.2564964 |
| Q1 | 7 |
| median | 31.52000046 |
| Q3 | 64.80000305 |
| 95-th percentile | 132.2899933 |
| Maximum | 911.7999878 |
| Range | 5186.779968 |
| Interquartile range (IQR) | 57.80000305 |
Descriptive statistics
| Standard deviation | 104.4338599 |
|---|---|
| Coefficient of variation (CV) | 4.753137458 |
| Kurtosis | 71.38010222 |
| Mean | 21.97156317 |
| Median Absolute Deviation (MAD) | 56.08786643 |
| Skewness | -4.742049787 |
| Sum | 3966042.924 |
| Variance | 10906.43109 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-4274.97998 -1355.61499 -1083.169983 -824.94000245 -674.98498535 ... 239.8199997 240.19000245 245.32499695 720.9499817 911.7999878 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 1177 | 0.7% | |
| 143.9900055 | 199 | 0.1% | |
| 72 | 194 | 0.1% | |
| 46.79999924 | 188 | 0.1% | |
| 24 | 181 | 0.1% | |
| 18 | 175 | 0.1% | |
| 63.70000076 | 172 | 0.1% | |
| 62.40000153 | 168 | 0.1% | |
| 12 | 166 | 0.1% | |
| 14.39999962 | 166 | 0.1% | |
| Other values (21986) | 177722 | 98.5% |
| Value | Count | Frequency (%) | |
| -4274.97998 | 1 | < 0.1% | |
| -3442.5 | 1 | < 0.1% | |
| -3366 | 1 | < 0.1% | |
| -3000 | 1 | < 0.1% | |
| -2592 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 911.7999878 | 1 | < 0.1% | |
| 864 | 1 | < 0.1% | |
| 721.5999756 | 1 | < 0.1% | |
| 720.2999878 | 1 | < 0.1% | |
| 720 | 2 | < 0.1% |
| Distinct count | 2927 |
|---|---|
| Unique (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 183.1017509 |
|---|---|
| Minimum | 7.489999771 |
| Maximum | 1939.98999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 7.489999771 |
|---|---|
| 5-th percentile | 41.5 |
| Q1 | 104.3799973 |
| median | 163.9900055 |
| Q3 | 247.3999939 |
| 95-th percentile | 383.980011 |
| Maximum | 1939.98999 |
| Range | 1932.49999 |
| Interquartile range (IQR) | 143.0199966 |
Descriptive statistics
| Standard deviation | 120.0415784 |
|---|---|
| Coefficient of variation (CV) | 0.6556003851 |
| Kurtosis | 23.9241351 |
| Mean | 183.1017509 |
| Median Absolute Deviation (MAD) | 87.65783926 |
| Skewness | 2.888772293 |
| Sum | 33051330.86 |
| Variance | 14409.98055 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 7.48999977 8.43000031 8.48000002 8.57499981 8.67499971 ... 1057.4949951 1215. 1492.494995 1549.994995 1939.98999 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 122.8399963 | 1264 | 0.7% | |
| 109.1900024 | 1247 | 0.7% | |
| 129.9900055 | 1243 | 0.7% | |
| 127.3899994 | 1243 | 0.7% | |
| 97.48999786 | 1243 | 0.7% | |
| 126.0899963 | 1243 | 0.7% | |
| 107.8899994 | 1243 | 0.7% | |
| 110.4899979 | 1243 | 0.7% | |
| 116.9899979 | 1243 | 0.7% | |
| 118.2900009 | 1243 | 0.7% | |
| Other values (2917) | 168053 | 93.1% |
| Value | Count | Frequency (%) | |
| 7.489999771 | 3 | < 0.1% | |
| 7.989999771 | 3 | < 0.1% | |
| 8.18999958 | 3 | < 0.1% | |
| 8.289999962 | 3 | < 0.1% | |
| 8.390000343 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1939.98999 | 1 | < 0.1% | |
| 1919.98999 | 1 | < 0.1% | |
| 1899.98999 | 1 | < 0.1% | |
| 1889.98999 | 1 | < 0.1% | |
| 1859.98999 | 1 | < 0.1% |
Delivery Status
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Late delivery | |
|---|---|
| Advance shipping | |
| Shipping on time | |
| Shipping canceled | 7754 |
| Value | Count | Frequency (%) | |
| Late delivery | 98972 | 54.8% | |
| Advance shipping | 41589 | 23.0% | |
| Shipping on time | 32193 | 17.8% | |
| Shipping canceled | 7754 | 4.3% |
Length
| Max length | 17 |
|---|---|
| Mean length | 14.39806546 |
| Min length | 13 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 17 | 81.0% | |
| Uppercase_Letter | 3 | 14.3% | |
| Space_Separator | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| Latin | 20 | 95.2% | |
| Common | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| ASCII | 21 | 100.0% |
Late_delivery_risk
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 98972 | 54.8% | |
| 0 | 81536 | 45.2% |
| Distinct count | 50 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Cleats | |
|---|---|
| Men's Footwear | |
| Women's Apparel | |
| Indoor/Outdoor Games | |
| Fishing | |
| Other values (45) |
| Value | Count | Frequency (%) | |
| Cleats | 24551 | 13.6% | |
| Men's Footwear | 22246 | 12.3% | |
| Women's Apparel | 21035 | 11.7% | |
| Indoor/Outdoor Games | 19298 | 10.7% | |
| Fishing | 17325 | 9.6% | |
| Water Sports | 15540 | 8.6% | |
| Camping & Hiking | 13729 | 7.6% | |
| Cardio Equipment | 12487 | 6.9% | |
| Shop By Sport | 10984 | 6.1% | |
| Electronics | 3156 | 1.7% | |
| Other values (40) | 20157 | 11.2% |
Length
| Max length | 20 |
|---|---|
| Mean length | 12.70769163 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 24 | 49.0% | |
| Uppercase_Letter | 19 | 38.8% | |
| Other_Punctuation | 4 | 8.2% | |
| Space_Separator | 1 | 2.0% | |
| Dash_Punctuation | 1 | 2.0% |
| Value | Count | Frequency (%) | |
| Latin | 43 | 87.8% | |
| Common | 6 | 12.2% |
| Value | Count | Frequency (%) | |
| ASCII | 49 | 100.0% |
| Distinct count | 562 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Caguas | |
|---|---|
| Chicago | 3885 |
| Los Angeles | 3416 |
| Brooklyn | 3412 |
| New York | 1816 |
| Other values (557) |
| Value | Count | Frequency (%) | |
| Caguas | 66768 | 37.0% | |
| Chicago | 3885 | 2.2% | |
| Los Angeles | 3416 | 1.9% | |
| Brooklyn | 3412 | 1.9% | |
| New York | 1816 | 1.0% | |
| Philadelphia | 1577 | 0.9% | |
| Bronx | 1500 | 0.8% | |
| San Diego | 1437 | 0.8% | |
| Miami | 1314 | 0.7% | |
| Houston | 1297 | 0.7% | |
| Other values (552) | 94086 | 52.1% |
Length
| Max length | 20 |
|---|---|
| Mean length | 7.708683272 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 26 | 50.0% | |
| Uppercase_Letter | 25 | 48.1% | |
| Space_Separator | 1 | 1.9% |
| Value | Count | Frequency (%) | |
| Latin | 51 | 98.1% | |
| Common | 1 | 1.9% |
| Value | Count | Frequency (%) | |
| ASCII | 52 | 100.0% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| EE. UU. | |
|---|---|
| Puerto Rico |
| Value | Count | Frequency (%) | |
| EE. UU. | 111137 | 61.6% | |
| Puerto Rico | 69371 | 38.4% |
Length
| Max length | 11 |
|---|---|
| Mean length | 8.537239347 |
| Min length | 7 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 7 | 53.8% | |
| Uppercase_Letter | 4 | 30.8% | |
| Space_Separator | 1 | 7.7% | |
| Other_Punctuation | 1 | 7.7% |
| Value | Count | Frequency (%) | |
| Latin | 11 | 84.6% | |
| Common | 2 | 15.4% |
| Value | Count | Frequency (%) | |
| ASCII | 13 | 100.0% |
| Distinct count | 775 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Mary | |
|---|---|
| James | 1835 |
| Robert | 1759 |
| Michael | 1680 |
| David | 1625 |
| Other values (770) |
| Value | Count | Frequency (%) | |
| Mary | 65150 | 36.1% | |
| James | 1835 | 1.0% | |
| Robert | 1759 | 1.0% | |
| Michael | 1680 | 0.9% | |
| David | 1625 | 0.9% | |
| John | 1446 | 0.8% | |
| William | 1365 | 0.8% | |
| Joseph | 1117 | 0.6% | |
| Jennifer | 1033 | 0.6% | |
| Richard | 1032 | 0.6% | |
| Other values (765) | 102466 | 56.8% |
Length
| Max length | 11 |
|---|---|
| Mean length | 5.274674807 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 26 | 50.0% | |
| Lowercase_Letter | 26 | 50.0% |
| Value | Count | Frequency (%) | |
| Latin | 52 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 52 | 100.0% |
| Distinct count | 1109 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Smith | |
|---|---|
| Johnson | 989 |
| Brown | 909 |
| Williams | 869 |
| Jones | 859 |
| Other values (1104) |
| Value | Count | Frequency (%) | |
| Smith | 64104 | 35.5% | |
| Johnson | 989 | 0.5% | |
| Brown | 909 | 0.5% | |
| Williams | 869 | 0.5% | |
| Jones | 859 | 0.5% | |
| Garcia | 724 | 0.4% | |
| Wilson | 675 | 0.4% | |
| Taylor | 661 | 0.4% | |
| Davis | 640 | 0.4% | |
| Moore | 599 | 0.3% | |
| Other values (1099) | 109479 | 60.7% |
Length
| Max length | 12 |
|---|---|
| Mean length | 5.712395019 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 26 | 51.0% | |
| Uppercase_Letter | 25 | 49.0% |
| Value | Count | Frequency (%) | |
| Latin | 51 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 51 | 100.0% |
Customer Segment
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
| Value | Count | Frequency (%) | |
| Consumer | 93501 | 51.8% | |
| Corporate | 54784 | 30.3% | |
| Home Office | 32223 | 17.9% |
Length
| Max length | 11 |
|---|---|
| Mean length | 8.839037605 |
| Min length | 8 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 13 | 76.5% | |
| Uppercase_Letter | 3 | 17.6% | |
| Space_Separator | 1 | 5.9% |
| Value | Count | Frequency (%) | |
| Latin | 16 | 94.1% | |
| Common | 1 | 5.9% |
| Value | Count | Frequency (%) | |
| ASCII | 17 | 100.0% |
| Distinct count | 44 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| PR | |
|---|---|
| CA | |
| NY | 11327 |
| TX | 9102 |
| IL | 7630 |
| Other values (39) |
| Value | Count | Frequency (%) | |
| PR | 69371 | 38.4% | |
| CA | 29221 | 16.2% | |
| NY | 11327 | 6.3% | |
| TX | 9102 | 5.0% | |
| IL | 7630 | 4.2% | |
| FL | 5456 | 3.0% | |
| OH | 4095 | 2.3% | |
| PA | 3824 | 2.1% | |
| MI | 3804 | 2.1% | |
| NJ | 3191 | 1.8% | |
| Other values (34) | 33487 | 18.6% |
Length
| Max length | 2 |
|---|---|
| Mean length | 2 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 24 | 100.0% |
| Value | Count | Frequency (%) | |
| Latin | 24 | 100.0% |
| Value | Count | Frequency (%) | |
| ASCII | 24 | 100.0% |
| Distinct count | 7456 |
|---|---|
| Unique (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 9126 Wishing Expressway | 122 |
|---|---|
| 4388 Burning Goose Ridge | 117 |
| 4720 Noble Hills Wynd | 116 |
| 2878 Hazy Wagon Thicket | 113 |
| 398 Emerald Grove | 109 |
| Other values (7451) |
| Value | Count | Frequency (%) | |
| 9126 Wishing Expressway | 122 | 0.1% | |
| 4388 Burning Goose Ridge | 117 | 0.1% | |
| 4720 Noble Hills Wynd | 116 | 0.1% | |
| 2878 Hazy Wagon Thicket | 113 | 0.1% | |
| 398 Emerald Grove | 109 | 0.1% | |
| 3593 Blue Brook Acres | 108 | 0.1% | |
| 2210 Merry Leaf Row | 107 | 0.1% | |
| 6289 Rocky Way | 107 | 0.1% | |
| 2585 Silent Autumn Landing | 105 | 0.1% | |
| 7694 Velvet Turnabout | 103 | 0.1% | |
| Other values (7446) | 179401 | 99.4% |
Length
| Max length | 33 |
|---|---|
| Mean length | 19.95735923 |
| Min length | 12 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 25 | 41.0% | |
| Uppercase_Letter | 24 | 39.3% | |
| Decimal_Number | 10 | 16.4% | |
| Space_Separator | 1 | 1.6% | |
| Dash_Punctuation | 1 | 1.6% |
| Value | Count | Frequency (%) | |
| Latin | 49 | 80.3% | |
| Common | 12 | 19.7% |
| Value | Count | Frequency (%) | |
| ASCII | 61 | 100.0% |
| Distinct count | 995 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35920.2467 |
|---|---|
| Minimum | 603 |
| Maximum | 99205 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 603 |
|---|---|
| 5-th percentile | 725 |
| Q1 | 725 |
| median | 19380 |
| Q3 | 78202.5 |
| 95-th percentile | 94538 |
| Maximum | 99205 |
| Range | 98602 |
| Interquartile range (IQR) | 77477.5 |
Descriptive statistics
| Standard deviation | 37542.21461 |
|---|---|
| Coefficient of variation (CV) | 1.045154699 |
| Kurtosis | -1.451371047 |
| Mean | 35920.2467 |
| Median Absolute Deviation (MAD) | 34305.49878 |
| Skewness | 0.4909268924 |
| Sum | 6483891891 |
| Variance | 1409417878 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 603. 607.5 677. 695.5 711.5 ... 98044.5 98161.5 98217. 98308. 99205. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 725 | 66768 | 37.0% | |
| 921 | 337 | 0.2% | |
| 23455 | 334 | 0.2% | |
| 957 | 297 | 0.2% | |
| 79109 | 292 | 0.2% | |
| 33324 | 283 | 0.2% | |
| 80012 | 280 | 0.2% | |
| 33624 | 261 | 0.1% | |
| 92115 | 256 | 0.1% | |
| 97701 | 254 | 0.1% | |
| Other values (985) | 111146 | 61.6% |
| Value | Count | Frequency (%) | |
| 603 | 50 | < 0.1% | |
| 612 | 122 | 0.1% | |
| 674 | 169 | 0.1% | |
| 680 | 133 | 0.1% | |
| 685 | 126 | 0.1% |
| Value | Count | Frequency (%) | |
| 99205 | 43 | < 0.1% | |
| 98632 | 67 | < 0.1% | |
| 98390 | 28 | < 0.1% | |
| 98226 | 47 | < 0.1% | |
| 98208 | 95 | 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Fan Shop | |
|---|---|
| Apparel | |
| Golf | |
| Footwear | |
| Outdoors | 9686 |
| Other values (6) | 7226 |
| Value | Count | Frequency (%) | |
| Fan Shop | 66861 | 37.0% | |
| Apparel | 48990 | 27.1% | |
| Golf | 33220 | 18.4% | |
| Footwear | 14525 | 8.0% | |
| Outdoors | 9686 | 5.4% | |
| Fitness | 2479 | 1.4% | |
| Discs Shop | 2025 | 1.1% | |
| Technology | 1463 | 0.8% | |
| Pet Shop | 492 | 0.3% | |
| Book Shop | 405 | 0.2% |
Length
| Max length | 18 |
|---|---|
| Mean length | 7.039665832 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 19 | 63.3% | |
| Uppercase_Letter | 10 | 33.3% | |
| Space_Separator | 1 | 3.3% |
| Value | Count | Frequency (%) | |
| Latin | 29 | 96.7% | |
| Common | 1 | 3.3% |
| Value | Count | Frequency (%) | |
| ASCII | 30 | 100.0% |
Latitude
Real number (ℝ)
| Distinct count | 11247 |
|---|---|
| Unique (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.71985802 |
|---|---|
| Minimum | -33.93755341 |
| Maximum | 48.78193283 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -33.93755341 |
|---|---|
| 5-th percentile | 18.21293068 |
| Q1 | 18.26543236 |
| median | 33.14486313 |
| Q3 | 39.27961731 |
| 95-th percentile | 42.39110184 |
| Maximum | 48.78193283 |
| Range | 82.71948624 |
| Interquartile range (IQR) | 21.01418495 |
Descriptive statistics
| Standard deviation | 9.813737303 |
|---|---|
| Coefficient of variation (CV) | 0.3302080816 |
| Kurtosis | -1.555431167 |
| Mean | 29.71985802 |
| Median Absolute Deviation (MAD) | 9.08998316 |
| Skewness | -0.09793750906 |
| Sum | 5364672.132 |
| Variance | 96.30943985 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-33.93755341 -7.97753143 17.99465561 18.02520657 18.02536583 ... 47.91032028 47.91926957 48.3484974 48.77644539 48.78193283], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 18.2275734 | 417 | 0.2% | |
| 39.49591446 | 370 | 0.2% | |
| 18.22757721 | 300 | 0.2% | |
| 36.91083145 | 280 | 0.2% | |
| 26.0984993 | 270 | 0.1% | |
| 18.38011932 | 267 | 0.1% | |
| 33.04647064 | 234 | 0.1% | |
| 26.21472931 | 218 | 0.1% | |
| 32.75856018 | 218 | 0.1% | |
| 40.64759827 | 212 | 0.1% | |
| Other values (11237) | 177722 | 98.5% |
| Value | Count | Frequency (%) | |
| -33.93755341 | 9 | < 0.1% | |
| 17.98249054 | 38 | < 0.1% | |
| 18.00682068 | 22 | < 0.1% | |
| 18.01836205 | 20 | < 0.1% | |
| 18.02520371 | 17 | < 0.1% |
| Value | Count | Frequency (%) | |
| 48.78193283 | 6 | < 0.1% | |
| 48.77095795 | 41 | < 0.1% | |
| 47.92603684 | 7 | < 0.1% | |
| 47.91250229 | 4 | < 0.1% | |
| 47.90813828 | 20 | < 0.1% |
| Distinct count | 4485 |
|---|---|
| Unique (%) | 2.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -84.91444872 |
|---|---|
| Minimum | -158.0259857 |
| Maximum | 115.2630768 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -158.0259857 |
|---|---|
| 5-th percentile | -121.4349442 |
| Q1 | -98.44631195 |
| median | -76.84075928 |
| Q3 | -66.37058258 |
| 95-th percentile | -66.18312836 |
| Maximum | 115.2630768 |
| Range | 273.2890625 |
| Interquartile range (IQR) | 32.07572937 |
Descriptive statistics
| Standard deviation | 21.4322901 |
|---|---|
| Coefficient of variation (CV) | -0.252398625 |
| Kurtosis | 2.181384875 |
| Mean | -84.91444872 |
| Median Absolute Deviation (MAD) | 17.88714999 |
| Skewness | -0.4983960889 |
| Sum | -15327737.31 |
| Variance | 459.3430591 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-158.0259857 -158.0131302 -158.00472255 -158.0046539 -157.9979477 ... 47.83176613 79.77704621 83.60233688 115.1564331 115.2630768 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| -66.3706131 | 3821 | 2.1% | |
| -66.37057495 | 3523 | 2.0% | |
| -66.37059021 | 3522 | 2.0% | |
| -66.37050629 | 3465 | 1.9% | |
| -66.37055206 | 3417 | 1.9% | |
| -66.37052918 | 3408 | 1.9% | |
| -66.3705368 | 3377 | 1.9% | |
| -66.37055969 | 3242 | 1.8% | |
| -66.37060547 | 3230 | 1.8% | |
| -66.37058258 | 3155 | 1.7% | |
| Other values (4475) | 146348 | 81.1% |
| Value | Count | Frequency (%) | |
| -158.0259857 | 73 | < 0.1% | |
| -158.016037 | 134 | 0.1% | |
| -158.0102234 | 18 | < 0.1% | |
| -158.0047607 | 7 | < 0.1% | |
| -158.0046844 | 43 | < 0.1% |
| Value | Count | Frequency (%) | |
| 115.2630768 | 17 | < 0.1% | |
| 115.0497894 | 17 | < 0.1% | |
| 84.74267578 | 8 | < 0.1% | |
| 82.46199799 | 22 | < 0.1% | |
| 77.09209442 | 32 | < 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| LATAM | |
|---|---|
| Europe | |
| Pacific Asia | |
| USCA | |
| Africa |
| Value | Count | Frequency (%) | |
| LATAM | 51594 | 28.6% | |
| Europe | 50247 | 27.8% | |
| Pacific Asia | 41254 | 22.9% | |
| USCA | 25799 | 14.3% | |
| Africa | 11614 | 6.4% |
Length
| Max length | 12 |
|---|---|
| Mean length | 6.79958783 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 10 | 50.0% | |
| Uppercase_Letter | 9 | 45.0% | |
| Space_Separator | 1 | 5.0% |
| Value | Count | Frequency (%) | |
| Latin | 19 | 95.0% | |
| Common | 1 | 5.0% |
| Value | Count | Frequency (%) | |
| ASCII | 20 | 100.0% |
| Distinct count | 3597 |
|---|---|
| Unique (%) | 2.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Santo Domingo | 2211 |
|---|---|
| New York City | 2202 |
| Los Angeles | 1845 |
| Tegucigalpa | 1783 |
| Managua | 1682 |
| Other values (3592) |
| Value | Count | Frequency (%) | |
| Santo Domingo | 2211 | 1.2% | |
| New York City | 2202 | 1.2% | |
| Los Angeles | 1845 | 1.0% | |
| Tegucigalpa | 1783 | 1.0% | |
| Managua | 1682 | 0.9% | |
| Mexico City | 1484 | 0.8% | |
| Manila | 1379 | 0.8% | |
| Philadelphia | 1302 | 0.7% | |
| San Francisco | 1297 | 0.7% | |
| London | 1187 | 0.7% | |
| Other values (3587) | 164136 | 90.9% |
Length
| Max length | 35 |
|---|---|
| Mean length | 8.554296762 |
| Min length | 2 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 42 | 53.2% | |
| Uppercase_Letter | 29 | 36.7% | |
| Other_Punctuation | 3 | 3.8% | |
| Control | 1 | 1.3% | |
| Open_Punctuation | 1 | 1.3% | |
| Close_Punctuation | 1 | 1.3% | |
| Space_Separator | 1 | 1.3% | |
| Dash_Punctuation | 1 | 1.3% |
| Value | Count | Frequency (%) | |
| Latin | 71 | 89.9% | |
| Common | 8 | 10.1% |
| Value | Count | Frequency (%) | |
| ASCII | 59 | 100.0% |
| Distinct count | 164 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Estados Unidos | |
|---|---|
| Francia | 13221 |
| México | 13172 |
| Alemania | 9563 |
| Australia | 8497 |
| Other values (159) |
| Value | Count | Frequency (%) | |
| Estados Unidos | 24840 | 13.8% | |
| Francia | 13221 | 7.3% | |
| México | 13172 | 7.3% | |
| Alemania | 9563 | 5.3% | |
| Australia | 8497 | 4.7% | |
| Brasil | 7987 | 4.4% | |
| Reino Unido | 7301 | 4.0% | |
| China | 5757 | 3.2% | |
| Italia | 4988 | 2.8% | |
| India | 4782 | 2.6% | |
| Other values (154) | 80400 | 44.5% |
Length
| Max length | 31 |
|---|---|
| Mean length | 8.772896492 |
| Min length | 4 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 32 | 52.5% | |
| Uppercase_Letter | 25 | 41.0% | |
| Space_Separator | 1 | 1.6% | |
| Close_Punctuation | 1 | 1.6% | |
| Dash_Punctuation | 1 | 1.6% | |
| Open_Punctuation | 1 | 1.6% |
| Value | Count | Frequency (%) | |
| Latin | 57 | 93.4% | |
| Common | 4 | 6.6% |
| Value | Count | Frequency (%) | |
| ASCII | 54 | 100.0% |
| Distinct count | 65741 |
|---|---|
| Unique (%) | 36.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Minimum | 2015-01-01 00:00:00 |
|---|---|
| Maximum | 2018-01-31 23:38:00 |
Histogram
| Distinct count | 1017 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.6639984 |
|---|---|
| Minimum | 0 |
| Maximum | 500 |
| Zeros | 10028 |
| Zeros (%) | 5.6% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5.400000095 |
| median | 14 |
| Q3 | 29.98999977 |
| 95-th percentile | 62.5 |
| Maximum | 500 |
| Range | 500 |
| Interquartile range (IQR) | 24.58999968 |
Descriptive statistics
| Standard deviation | 21.80075323 |
|---|---|
| Coefficient of variation (CV) | 1.055011368 |
| Kurtosis | 25.23396113 |
| Mean | 20.6639984 |
| Median Absolute Deviation (MAD) | 15.6809574 |
| Skewness | 3.040034424 |
| Sum | 3730017.023 |
| Variance | 475.2728412 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0.00000000e+00 5.00000005e-02 1.05000000e-01 1.35000001e-01 2.25000001e-01 ... 2.12500000e+02 3.10000000e+02 3.67500000e+02 3.87500000e+02 5.00000000e+02], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0 | 10028 | 5.6% | |
| 6 | 4589 | 2.5% | |
| 12 | 4067 | 2.3% | |
| 4 | 3647 | 2.0% | |
| 8 | 3626 | 2.0% | |
| 10 | 3424 | 1.9% | |
| 36 | 3268 | 1.8% | |
| 30 | 3230 | 1.8% | |
| 20 | 3123 | 1.7% | |
| 9 | 2964 | 1.6% | |
| Other values (1007) | 138542 | 76.8% |
| Value | Count | Frequency (%) | |
| 0 | 10028 | 5.6% | |
| 0.100000001 | 3 | < 0.1% | |
| 0.109999999 | 15 | < 0.1% | |
| 0.119999997 | 29 | < 0.1% | |
| 0.150000006 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 500 | 1 | < 0.1% | |
| 400 | 1 | < 0.1% | |
| 375 | 25 | < 0.1% | |
| 360 | 1 | < 0.1% | |
| 340 | 1 | < 0.1% |
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1016681814 |
|---|---|
| Minimum | 0 |
| Maximum | 0.25 |
| Zeros | 10028 |
| Zeros (%) | 5.6% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.039999999 |
| median | 0.100000001 |
| Q3 | 0.159999996 |
| 95-th percentile | 0.25 |
| Maximum | 0.25 |
| Range | 0.25 |
| Interquartile range (IQR) | 0.119999997 |
Descriptive statistics
| Standard deviation | 0.07041558421 |
|---|---|
| Coefficient of variation (CV) | 0.6926019846 |
| Kurtosis | -0.9012042473 |
| Mean | 0.1016681814 |
| Median Absolute Deviation (MAD) | 0.06074105894 |
| Skewness | 0.3408986005 |
| Sum | 18351.92009 |
| Variance | 0.0049583545 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[0. 0.005 0.065 0.155 0.175 0.19 0.225 0.25 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0.129999995 | 10029 | 5.6% | |
| 0.119999997 | 10029 | 5.6% | |
| 0.180000007 | 10029 | 5.6% | |
| 0.050000001 | 10029 | 5.6% | |
| 0.029999999 | 10029 | 5.6% | |
| 0.200000003 | 10029 | 5.6% | |
| 0.150000006 | 10029 | 5.6% | |
| 0.01 | 10028 | 5.6% | |
| 0 | 10028 | 5.6% | |
| 0.039999999 | 10028 | 5.6% | |
| Other values (8) | 80221 | 44.4% |
| Value | Count | Frequency (%) | |
| 0 | 10028 | 5.6% | |
| 0.01 | 10028 | 5.6% | |
| 0.02 | 10027 | 5.6% | |
| 0.029999999 | 10029 | 5.6% | |
| 0.039999999 | 10028 | 5.6% |
| Value | Count | Frequency (%) | |
| 0.25 | 10028 | 5.6% | |
| 0.200000003 | 10029 | 5.6% | |
| 0.180000007 | 10029 | 5.6% | |
| 0.170000002 | 10028 | 5.6% | |
| 0.159999996 | 10028 | 5.6% |
Order Item Product Price
Real number (ℝ≥0)
| Distinct count | 75 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141.2221386 |
|---|---|
| Minimum | 9.989999771 |
| Maximum | 1999.98999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.989999771 |
|---|---|
| 5-th percentile | 31.98999977 |
| Q1 | 50 |
| median | 59.99000168 |
| Q3 | 199.9900055 |
| 95-th percentile | 399.980011 |
| Maximum | 1999.98999 |
| Range | 1989.99999 |
| Interquartile range (IQR) | 149.9900055 |
Descriptive statistics
| Standard deviation | 139.7269598 |
|---|---|
| Coefficient of variation (CV) | 0.989412575 |
| Kurtosis | 23.31915976 |
| Mean | 141.2221386 |
| Median Absolute Deviation (MAD) | 102.8044493 |
| Skewness | 3.191550035 |
| Sum | 25491725.79 |
| Variance | 19523.62329 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 9.98999977 11.41499996 15.48999977 16.98999977 18.98999977 ... 566.28500365 799.9899902 1249.9949951 1749.994995 1999.98999 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 59.99000168 | 24820 | 13.8% | |
| 129.9900055 | 22372 | 12.4% | |
| 50 | 21035 | 11.7% | |
| 49.97999954 | 19298 | 10.7% | |
| 399.980011 | 17325 | 9.6% | |
| 199.9900055 | 15622 | 8.7% | |
| 299.980011 | 13729 | 7.6% | |
| 99.98999786 | 12433 | 6.9% | |
| 39.99000168 | 11201 | 6.2% | |
| 24.98999977 | 2339 | 1.3% | |
| Other values (65) | 20334 | 11.3% |
| Value | Count | Frequency (%) | |
| 9.989999771 | 285 | 0.2% | |
| 11.28999996 | 271 | 0.2% | |
| 11.53999996 | 529 | 0.3% | |
| 14.98999977 | 593 | 0.3% | |
| 15.98999977 | 602 | 0.3% |
| Value | Count | Frequency (%) | |
| 1999.98999 | 15 | < 0.1% | |
| 1500 | 442 | 0.2% | |
| 999.9899902 | 10 | < 0.1% | |
| 599.9899902 | 21 | < 0.1% | |
| 532.5800171 | 484 | 0.3% |
Order Item Profit Ratio
Real number (ℝ)
| Distinct count | 162 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1206388082 |
|---|---|
| Minimum | -2.75 |
| Maximum | 0.5 |
| Zeros | 1177 |
| Zeros (%) | 0.7% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | -2.75 |
|---|---|
| 5-th percentile | -0.769999981 |
| Q1 | 0.079999998 |
| median | 0.270000011 |
| Q3 | 0.360000014 |
| 95-th percentile | 0.479999989 |
| Maximum | 0.5 |
| Range | 3.25 |
| Interquartile range (IQR) | 0.280000016 |
Descriptive statistics
| Standard deviation | 0.4668059291 |
|---|---|
| Coefficient of variation (CV) | 3.869450768 |
| Kurtosis | 10.156661 |
| Mean | 0.1206388082 |
| Median Absolute Deviation (MAD) | 0.2941284219 |
| Skewness | -2.89347205 |
| Sum | 21776.26999 |
| Variance | 0.2179077754 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[-2.75 -2.72500002 -2.67500007 -2.625 -2.47500002 ... 0.465 0.47499999 0.485 0.495 0.5 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 0.479999989 | 9197 | 5.1% | |
| 0.349999994 | 7996 | 4.4% | |
| 0.25999999 | 6577 | 3.6% | |
| 0.340000004 | 6506 | 3.6% | |
| 0.469999999 | 6378 | 3.5% | |
| 0.360000014 | 6107 | 3.4% | |
| 0.330000013 | 5789 | 3.2% | |
| 0.49000001 | 5686 | 3.1% | |
| 0.289999992 | 5478 | 3.0% | |
| 0.280000001 | 5402 | 3.0% | |
| Other values (152) | 115392 | 63.9% |
| Value | Count | Frequency (%) | |
| -2.75 | 72 | < 0.1% | |
| -2.700000048 | 252 | 0.1% | |
| -2.650000095 | 90 | < 0.1% | |
| -2.599999905 | 181 | 0.1% | |
| -2.549999952 | 234 | 0.1% |
| Value | Count | Frequency (%) | |
| 0.5 | 2529 | 1.4% | |
| 0.49000001 | 5686 | 3.1% | |
| 0.479999989 | 9197 | 5.1% | |
| 0.469999999 | 6378 | 3.5% | |
| 0.460000008 | 4822 | 2.7% |
Order Item Quantity
Real number (ℝ≥0)
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.127706251 |
|---|---|
| Minimum | 1 |
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.453469109 |
|---|---|
| Coefficient of variation (CV) | 0.6831154951 |
| Kurtosis | -0.7538622094 |
| Mean | 2.127706251 |
| Median Absolute Deviation (MAD) | 1.267267703 |
| Skewness | 0.8801600832 |
| Sum | 384068 |
| Variance | 2.112572451 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[1. 1.5 4.5 5. ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 1 | 99123 | 54.9% | |
| 5 | 20385 | 11.3% | |
| 3 | 20350 | 11.3% | |
| 4 | 20335 | 11.3% | |
| 2 | 20315 | 11.3% |
| Value | Count | Frequency (%) | |
| 1 | 99123 | 54.9% | |
| 2 | 20315 | 11.3% | |
| 3 | 20350 | 11.3% | |
| 4 | 20335 | 11.3% | |
| 5 | 20385 | 11.3% |
| Value | Count | Frequency (%) | |
| 5 | 20385 | 11.3% | |
| 4 | 20335 | 11.3% | |
| 3 | 20350 | 11.3% | |
| 2 | 20315 | 11.3% | |
| 1 | 99123 | 54.9% |
| Distinct count | 193 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 203.7654958 |
|---|---|
| Minimum | 9.989999771 |
| Maximum | 1999.98999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.4 MiB |
Quantile statistics
| Minimum | 9.989999771 |
|---|---|
| 5-th percentile | 49.97999954 |
| Q1 | 119.9800034 |
| median | 199.9199982 |
| Q3 | 299.9500122 |
| 95-th percentile | 399.980011 |
| Maximum | 1999.98999 |
| Range | 1989.99999 |
| Interquartile range (IQR) | 179.9700088 |
Descriptive statistics
| Standard deviation | 132.2707879 |
|---|---|
| Coefficient of variation (CV) | 0.6491324123 |
| Kurtosis | 23.94036104 |
| Mean | 203.7654958 |
| Median Absolute Deviation (MAD) | 95.93699883 |
| Skewness | 2.884585489 |
| Sum | 36781302.12 |
| Variance | 17495.56132 |
Histogram with fixed size bins (bins=10)
Histogram with variable size bins (bins=[ 9.98999977 10.63999987 13.26499987 16.98999977 19.98499966 ... 566.28500365 799.9899902 1249.9949951 1749.994995 1999.98999 ], "bayesian blocks" binning strategy used)
| Value | Count | Frequency (%) | |
| 129.9900055 | 22372 | 12.4% | |
| 399.980011 | 17325 | 9.6% | |
| 199.9900055 | 15622 | 8.7% | |
| 299.980011 | 13729 | 7.6% | |
| 179.9700012 | 5016 | 2.8% | |
| 299.9500122 | 4988 | 2.8% | |
| 119.9800034 | 4968 | 2.8% | |
| 239.9600067 | 4955 | 2.7% | |
| 59.99000168 | 4893 | 2.7% | |
| 50 | 4432 | 2.5% | |
| Other values (183) | 82208 | 45.5% |
| Value | Count | Frequency (%) | |
| 9.989999771 | 56 | < 0.1% | |
| 11.28999996 | 271 | 0.2% | |
| 11.53999996 | 529 | 0.3% | |
| 14.98999977 | 124 | 0.1% | |
| 15.98999977 | 118 | 0.1% |
| Value | Count | Frequency (%) | |
| 1999.98999 | 15 | < 0.1% | |
| 1500 | 442 | 0.2% | |
| 999.9899902 | 10 | < 0.1% | |
| 599.9899902 | 21 | < 0.1% | |
| 532.5800171 | 484 | 0.3% |
| Distinct count | 23 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Central America | |
|---|---|
| Western Europe | |
| South America | 14935 |
| Oceania | 10148 |
| Northern Europe | 9790 |
| Other values (18) |
| Value | Count | Frequency (%) | |
| Central America | 28341 | 15.7% | |
| Western Europe | 27107 | 15.0% | |
| South America | 14935 | 8.3% | |
| Oceania | 10148 | 5.6% | |
| Northern Europe | 9790 | 5.4% | |
| Southeast Asia | 9535 | 5.3% | |
| Southern Europe | 9430 | 5.2% | |
| Caribbean | 8318 | 4.6% | |
| West of USA | 7993 | 4.4% | |
| South Asia | 7730 | 4.3% | |
| Other values (13) | 47181 | 26.1% |
Length
| Max length | 15 |
|---|---|
| Mean length | 12.63423782 |
| Min length | 6 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 17 | 65.4% | |
| Uppercase_Letter | 8 | 30.8% | |
| Space_Separator | 1 | 3.8% |
| Value | Count | Frequency (%) | |
| Latin | 25 | 96.2% | |
| Common | 1 | 3.8% |
| Value | Count | Frequency (%) | |
| ASCII | 26 | 100.0% |
| Distinct count | 1089 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Inglaterra | 6721 |
|---|---|
| California | 4966 |
| Isla de Francia | 4580 |
| Renania del Norte-Westfalia | 3302 |
| San Salvador | 3055 |
| Other values (1084) |
| Value | Count | Frequency (%) | |
| Inglaterra | 6721 | 3.7% | |
| California | 4966 | 2.8% | |
| Isla de Francia | 4580 | 2.5% | |
| Renania del Norte-Westfalia | 3302 | 1.8% | |
| San Salvador | 3055 | 1.7% | |
| Nueva York | 2753 | 1.5% | |
| Distrito Federal | 2559 | 1.4% | |
| Texas | 2446 | 1.4% | |
| Nueva Gales del Sur | 2370 | 1.3% | |
| Santo Domingo | 2211 | 1.2% | |
| Other values (1079) | 145545 | 80.6% |
Length
| Max length | 36 |
|---|---|
| Mean length | 10.87242117 |
| Min length | 3 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 45 | 54.2% | |
| Uppercase_Letter | 30 | 36.1% | |
| Control | 2 | 2.4% | |
| Other_Punctuation | 2 | 2.4% | |
| Open_Punctuation | 1 | 1.2% | |
| Close_Punctuation | 1 | 1.2% | |
| Space_Separator | 1 | 1.2% | |
| Dash_Punctuation | 1 | 1.2% |
| Value | Count | Frequency (%) | |
| Latin | 75 | 90.4% | |
| Common | 8 | 9.6% |
| Value | Count | Frequency (%) | |
| ASCII | 58 | 100.0% |
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| COMPLETE | |
|---|---|
| PENDING_PAYMENT | |
| PROCESSING | |
| PENDING | |
| CLOSED | |
| Other values (4) |
| Value | Count | Frequency (%) | |
| COMPLETE | 59487 | 33.0% | |
| PENDING_PAYMENT | 39829 | 22.1% | |
| PROCESSING | 21902 | 12.1% | |
| PENDING | 20224 | 11.2% | |
| CLOSED | 19616 | 10.9% | |
| ON_HOLD | 9803 | 5.4% | |
| SUSPECTED_FRAUD | 4062 | 2.3% | |
| CANCELED | 3692 | 2.0% | |
| PAYMENT_REVIEW | 1893 | 1.0% |
Length
| Max length | 15 |
|---|---|
| Mean length | 9.623972345 |
| Min length | 6 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 20 | 95.2% | |
| Connector_Punctuation | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| Latin | 20 | 95.2% | |
| Common | 1 | 4.8% |
| Value | Count | Frequency (%) | |
| ASCII | 21 | 100.0% |
| Distinct count | 118 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck | |
|---|---|
| http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat | |
| http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo | |
| http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest | |
| http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | |
| Other values (113) |
| Value | Count | Frequency (%) | |
| http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck | 24515 | 13.6% | |
| http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat | 22246 | 12.3% | |
| http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo | 21035 | 11.7% | |
| http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest | 19298 | 10.7% | |
| http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | 17325 | 9.6% | |
| http://images.acmesports.sports/Pelican+Sunstream+100+Kayak | 15500 | 8.6% | |
| http://images.acmesports.sports/Diamondback+Women%27s+Serene+Classic+Comfort+Bike+2014 | 13729 | 7.6% | |
| http://images.acmesports.sports/Nike+Men%27s+Free+5.0%2B+Running+Shoe | 12169 | 6.7% | |
| http://images.acmesports.sports/Under+Armour+Girls%27+Toddler+Spine+Surge+Running+Shoe | 10617 | 5.9% | |
| http://images.acmesports.sports/Fighting+video+games | 837 | 0.5% | |
| Other values (108) | 23237 | 12.9% |
| Value | Count | Frequency (%) | |
| http | 180508 | 100.0% |
| Value | Count | Frequency (%) | |
| images.acmesports.sports | 180508 | 100.0% |
| Value | Count | Frequency (%) | |
| /Perfect+Fitness+Perfect+Rip+Deck | 24515 | 13.6% | |
| /Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat | 22246 | 12.3% | |
| /Nike+Men%27s+Dri-FIT+Victory+Golf+Polo | 21035 | 11.7% | |
| /O%27Brien+Men%27s+Neoprene+Life+Vest | 19298 | 10.7% | |
| /Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | 17325 | 9.6% | |
| /Pelican+Sunstream+100+Kayak | 15500 | 8.6% | |
| /Diamondback+Women%27s+Serene+Classic+Comfort+Bike+2014 | 13729 | 7.6% | |
| /Nike+Men%27s+Free+5.0%2B+Running+Shoe | 12169 | 6.7% | |
| /Under+Armour+Girls%27+Toddler+Spine+Surge+Running+Shoe | 10617 | 5.9% | |
| /Fighting+video+games | 837 | 0.5% | |
| Other values (108) | 23237 | 12.9% |
| Value | Count | Frequency (%) | |
| 180508 | 100.0% |
| Value | Count | Frequency (%) | |
| 180508 | 100.0% |
| Distinct count | 118 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Perfect Fitness Perfect Rip Deck | |
|---|---|
| Nike Men's CJ Elite 2 TD Football Cleat | |
| Nike Men's Dri-FIT Victory Golf Polo | |
| O'Brien Men's Neoprene Life Vest | |
| Field & Stream Sportsman 16 Gun Fire Safe | |
| Other values (113) |
| Value | Count | Frequency (%) | |
| Perfect Fitness Perfect Rip Deck | 24515 | 13.6% | |
| Nike Men's CJ Elite 2 TD Football Cleat | 22246 | 12.3% | |
| Nike Men's Dri-FIT Victory Golf Polo | 21035 | 11.7% | |
| O'Brien Men's Neoprene Life Vest | 19298 | 10.7% | |
| Field & Stream Sportsman 16 Gun Fire Safe | 17325 | 9.6% | |
| Pelican Sunstream 100 Kayak | 15500 | 8.6% | |
| Diamondback Women's Serene Classic Comfort Bi | 13729 | 7.6% | |
| Nike Men's Free 5.0+ Running Shoe | 12169 | 6.7% | |
| Under Armour Girls' Toddler Spine Surge Runni | 10617 | 5.9% | |
| Fighting video games | 837 | 0.5% | |
| Other values (108) | 23237 | 12.9% |
Length
| Max length | 45 |
|---|---|
| Mean length | 35.12096971 |
| Min length | 5 |
| Value | Count | Frequency (%) | |
| Uppercase_Letter | 25 | 37.9% | |
| Lowercase_Letter | 24 | 36.4% | |
| Decimal_Number | 10 | 15.2% | |
| Other_Punctuation | 4 | 6.1% | |
| Math_Symbol | 1 | 1.5% | |
| Space_Separator | 1 | 1.5% | |
| Dash_Punctuation | 1 | 1.5% |
| Value | Count | Frequency (%) | |
| Latin | 49 | 74.2% | |
| Common | 17 | 25.8% |
| Value | Count | Frequency (%) | |
| ASCII | 66 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 180508 | 100.0% |
| Distinct count | 63692 |
|---|---|
| Unique (%) | 35.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Minimum | 2015-01-03 00:00:00 |
|---|---|
| Maximum | 2018-02-06 22:14:00 |
Histogram
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.4 MiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 9737 |
| Value | Count | Frequency (%) | |
| Standard Class | 107745 | 59.7% | |
| Second Class | 35214 | 19.5% | |
| First Class | 27812 | 15.4% | |
| Same Day | 9737 | 5.4% |
Length
| Max length | 14 |
|---|---|
| Mean length | 12.8239524 |
| Min length | 8 |
| Value | Count | Frequency (%) | |
| Lowercase_Letter | 13 | 72.2% | |
| Uppercase_Letter | 4 | 22.2% | |
| Space_Separator | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| Latin | 17 | 94.4% | |
| Common | 1 | 5.6% |
| Value | Count | Frequency (%) | |
| ASCII | 18 | 100.0% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
First rows
| df_index | Type | Days for shipping (real) | Days for shipment (scheduled) | Benefit per order | Sales per customer | Delivery Status | Late_delivery_risk | Category Name | Customer City | Customer Country | Customer Fname | Customer Lname | Customer Segment | Customer State | Customer Street | Customer Zipcode | Department Name | Latitude | Longitude | Market | Order City | Order Country | order date (DateOrders) | Order Item Discount | Order Item Discount Rate | Order Item Product Price | Order Item Profit Ratio | Order Item Quantity | Sales | Order Region | Order State | Order Status | Product Image | Product Name | Product Status | shipping date (DateOrders) | Shipping Mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | DEBIT | 3 | 4 | 91.250000 | 314.640015 | Advance shipping | 0 | Sporting Goods | Caguas | Puerto Rico | Cally | Holloway | Consumer | PR | 5365 Noble Nectar Island | 725 | Fitness | 18.251453 | -66.037056 | Pacific Asia | Bekasi | Indonesia | 2018-01-31 22:56:00 | 13.110000 | 0.04 | 327.75 | 0.29 | 1 | 327.75 | Southeast Asia | Java Occidental | COMPLETE | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-02-03 22:56:00 | Standard Class |
| 1 | 1 | TRANSFER | 5 | 4 | -249.089996 | 311.359985 | Late delivery | 1 | Sporting Goods | Caguas | Puerto Rico | Irene | Luna | Consumer | PR | 2679 Rustic Loop | 725 | Fitness | 18.279451 | -66.037064 | Pacific Asia | Bikaner | India | 2018-01-13 12:27:00 | 16.389999 | 0.05 | 327.75 | -0.80 | 1 | 327.75 | South Asia | Rajastán | PENDING | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-01-18 12:27:00 | Standard Class |
| 2 | 2 | CASH | 4 | 4 | -247.779999 | 309.720001 | Shipping on time | 0 | Sporting Goods | San Jose | EE. UU. | Gillian | Maldonado | Consumer | CA | 8510 Round Bear Gate | 95125 | Fitness | 37.292233 | -121.881279 | Pacific Asia | Bikaner | India | 2018-01-13 12:06:00 | 18.030001 | 0.06 | 327.75 | -0.80 | 1 | 327.75 | South Asia | Rajastán | CLOSED | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-01-17 12:06:00 | Standard Class |
| 3 | 3 | DEBIT | 3 | 4 | 22.860001 | 304.809998 | Advance shipping | 0 | Sporting Goods | Los Angeles | EE. UU. | Tana | Tate | Home Office | CA | 3200 Amber Bend | 90027 | Fitness | 34.125946 | -118.291016 | Pacific Asia | Townsville | Australia | 2018-01-13 11:45:00 | 22.940001 | 0.07 | 327.75 | 0.08 | 1 | 327.75 | Oceania | Queensland | COMPLETE | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-01-16 11:45:00 | Standard Class |
| 4 | 4 | PAYMENT | 2 | 4 | 134.210007 | 298.250000 | Advance shipping | 0 | Sporting Goods | Caguas | Puerto Rico | Orli | Hendricks | Corporate | PR | 8671 Iron Anchor Corners | 725 | Fitness | 18.253769 | -66.037048 | Pacific Asia | Townsville | Australia | 2018-01-13 11:24:00 | 29.500000 | 0.09 | 327.75 | 0.45 | 1 | 327.75 | Oceania | Queensland | PENDING_PAYMENT | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-01-15 11:24:00 | Standard Class |
| 5 | 5 | TRANSFER | 6 | 4 | 18.580000 | 294.980011 | Shipping canceled | 0 | Sporting Goods | Tonawanda | EE. UU. | Kimberly | Flowers | Consumer | NY | 2122 Hazy Corner | 14150 | Fitness | 43.013969 | -78.879066 | Pacific Asia | Toowoomba | Australia | 2018-01-13 11:03:00 | 32.779999 | 0.10 | 327.75 | 0.06 | 1 | 327.75 | Oceania | Queensland | CANCELED | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-01-19 11:03:00 | Standard Class |
| 6 | 6 | DEBIT | 2 | 1 | 95.180000 | 288.420013 | Late delivery | 1 | Sporting Goods | Caguas | Puerto Rico | Constance | Terrell | Home Office | PR | 1879 Green Pine Bank | 725 | Fitness | 18.242538 | -66.037056 | Pacific Asia | Guangzhou | China | 2018-01-13 10:42:00 | 39.330002 | 0.12 | 327.75 | 0.33 | 1 | 327.75 | Eastern Asia | Guangdong | COMPLETE | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-01-15 10:42:00 | First Class |
| 7 | 7 | TRANSFER | 2 | 1 | 68.430000 | 285.140015 | Late delivery | 1 | Sporting Goods | Miami | EE. UU. | Erica | Stevens | Corporate | FL | 7595 Cotton Log Row | 33162 | Fitness | 25.928869 | -80.162872 | Pacific Asia | Guangzhou | China | 2018-01-13 10:21:00 | 42.610001 | 0.13 | 327.75 | 0.24 | 1 | 327.75 | Eastern Asia | Guangdong | PROCESSING | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-01-15 10:21:00 | First Class |
| 8 | 8 | CASH | 3 | 2 | 133.720001 | 278.589996 | Late delivery | 1 | Sporting Goods | Caguas | Puerto Rico | Nichole | Olsen | Corporate | PR | 2051 Dusty Route | 725 | Fitness | 18.233223 | -66.037056 | Pacific Asia | Guangzhou | China | 2018-01-13 10:00:00 | 49.160000 | 0.15 | 327.75 | 0.48 | 1 | 327.75 | Eastern Asia | Guangdong | CLOSED | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-01-16 10:00:00 | Second Class |
| 9 | 9 | CASH | 2 | 1 | 132.149994 | 275.309998 | Late delivery | 1 | Sporting Goods | San Ramon | EE. UU. | Oprah | Delacruz | Corporate | CA | 9139 Blue Blossom Court | 94583 | Fitness | 37.773991 | -121.966629 | Pacific Asia | Guangzhou | China | 2018-01-13 09:39:00 | 52.439999 | 0.16 | 327.75 | 0.48 | 1 | 327.75 | Eastern Asia | Guangdong | CLOSED | http://images.acmesports.sports/Smart+watch | Smart watch | 0 | 2018-01-15 09:39:00 | First Class |
Last rows
| df_index | Type | Days for shipping (real) | Days for shipment (scheduled) | Benefit per order | Sales per customer | Delivery Status | Late_delivery_risk | Category Name | Customer City | Customer Country | Customer Fname | Customer Lname | Customer Segment | Customer State | Customer Street | Customer Zipcode | Department Name | Latitude | Longitude | Market | Order City | Order Country | order date (DateOrders) | Order Item Discount | Order Item Discount Rate | Order Item Product Price | Order Item Profit Ratio | Order Item Quantity | Sales | Order Region | Order State | Order Status | Product Image | Product Name | Product Status | shipping date (DateOrders) | Shipping Mode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180498 | 180509 | PAYMENT | 3 | 4 | 0.000000 | 335.980011 | Advance shipping | 0 | Fishing | Caguas | Puerto Rico | Melissa | Wilcox | Corporate | PR | 9453 High Concession | 725 | Fan Shop | 18.359095 | -66.079956 | Pacific Asia | Guangshui | China | 2016-01-16 06:49:00 | 64.0 | 0.16 | 399.980011 | 0.00 | 1 | 399.980011 | Eastern Asia | Hubei | PENDING_PAYMENT | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-19 06:49:00 | Standard Class |
| 180499 | 180510 | PAYMENT | 3 | 4 | 165.990005 | 331.980011 | Advance shipping | 0 | Fishing | Caguas | Puerto Rico | Melissa | Wilcox | Corporate | PR | 9453 High Concession | 725 | Fan Shop | 18.359095 | -66.079956 | Pacific Asia | Guangshui | China | 2016-01-16 06:49:00 | 68.0 | 0.17 | 399.980011 | 0.50 | 1 | 399.980011 | Eastern Asia | Hubei | PENDING_PAYMENT | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-19 06:49:00 | Standard Class |
| 180500 | 180511 | DEBIT | 2 | 2 | 157.429993 | 327.980011 | Shipping on time | 0 | Fishing | Chula Vista | EE. UU. | Olivia | Smith | Consumer | CA | 3760 Stony Promenade | 91911 | Fan Shop | 32.611141 | -117.073662 | Pacific Asia | Chengdu | China | 2016-01-16 06:28:00 | 72.0 | 0.18 | 399.980011 | 0.48 | 1 | 399.980011 | Eastern Asia | Sichuan | ON_HOLD | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-18 06:28:00 | Second Class |
| 180501 | 180512 | DEBIT | 6 | 4 | 86.400002 | 319.980011 | Late delivery | 1 | Fishing | Caguas | Puerto Rico | Mary | Madden | Home Office | PR | 9918 Lazy Cape | 725 | Fan Shop | 18.245256 | -66.370621 | Pacific Asia | Chengdu | China | 2016-01-16 06:07:00 | 80.0 | 0.20 | 399.980011 | 0.27 | 1 | 399.980011 | Eastern Asia | Sichuan | COMPLETE | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-22 06:07:00 | Standard Class |
| 180502 | 180513 | PAYMENT | 3 | 4 | 119.989998 | 299.989990 | Advance shipping | 0 | Fishing | Lancaster | EE. UU. | Mary | Smith | Home Office | OH | 8600 Red Goose Abbey | 43130 | Fan Shop | 39.715977 | -82.599297 | Pacific Asia | Shanghái | China | 2016-01-16 05:04:00 | 100.0 | 0.25 | 399.980011 | 0.40 | 1 | 399.980011 | Eastern Asia | Shanghái | PENDING_PAYMENT | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-19 05:04:00 | Standard Class |
| 180503 | 180514 | CASH | 4 | 4 | 40.000000 | 399.980011 | Shipping on time | 0 | Fishing | Brooklyn | EE. UU. | Maria | Peterson | Home Office | NY | 1322 Broad Glade | 11207 | Fan Shop | 40.640930 | -73.942711 | Pacific Asia | Shanghái | China | 2016-01-16 03:40:00 | 0.0 | 0.00 | 399.980011 | 0.10 | 1 | 399.980011 | Eastern Asia | Shanghái | CLOSED | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-20 03:40:00 | Standard Class |
| 180504 | 180515 | DEBIT | 3 | 2 | -613.770019 | 395.980011 | Late delivery | 1 | Fishing | Bakersfield | EE. UU. | Ronald | Clark | Corporate | CA | 7330 Broad Apple Moor | 93304 | Fan Shop | 35.362545 | -119.018700 | Pacific Asia | Hirakata | Japón | 2016-01-16 01:34:00 | 4.0 | 0.01 | 399.980011 | -1.55 | 1 | 399.980011 | Eastern Asia | Osaka | COMPLETE | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-19 01:34:00 | Second Class |
| 180505 | 180516 | TRANSFER | 5 | 4 | 141.110001 | 391.980011 | Late delivery | 1 | Fishing | Bristol | EE. UU. | John | Smith | Corporate | CT | 97 Burning Landing | 6010 | Fan Shop | 41.629959 | -72.967155 | Pacific Asia | Adelaide | Australia | 2016-01-15 21:00:00 | 8.0 | 0.02 | 399.980011 | 0.36 | 1 | 399.980011 | Oceania | Australia del Sur | PENDING | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-20 21:00:00 | Standard Class |
| 180506 | 180517 | PAYMENT | 3 | 4 | 186.229996 | 387.980011 | Advance shipping | 0 | Fishing | Caguas | Puerto Rico | Mary | Smith | Consumer | PR | 2585 Silent Autumn Landing | 725 | Fan Shop | 18.213350 | -66.370575 | Pacific Asia | Adelaide | Australia | 2016-01-15 20:18:00 | 12.0 | 0.03 | 399.980011 | 0.48 | 1 | 399.980011 | Oceania | Australia del Sur | PENDING_PAYMENT | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-18 20:18:00 | Standard Class |
| 180507 | 180518 | PAYMENT | 4 | 4 | 168.949997 | 383.980011 | Shipping on time | 0 | Fishing | Caguas | Puerto Rico | Andrea | Ortega | Consumer | PR | 697 Little Meadow | 725 | Fan Shop | 18.290380 | -66.370613 | Pacific Asia | Nagercoil | India | 2016-01-15 18:54:00 | 16.0 | 0.04 | 399.980011 | 0.44 | 1 | 399.980011 | South Asia | Tamil Nadu | PENDING_PAYMENT | http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe | Field & Stream Sportsman 16 Gun Fire Safe | 0 | 2016-01-19 18:54:00 | Standard Class |